/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80023
 Source Host           : 127.0.0.1:3306
 Source Schema         : slm

 Target Server Type    : MySQL
 Target Server Version : 80023
 File Encoding         : 65001

 Date: 23/01/2021 17:17:03
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for article
-- ----------------------------
DROP TABLE IF EXISTS `article`;
CREATE TABLE `article` (
  `id` int NOT NULL COMMENT '序号',
  `label` varchar(255) DEFAULT NULL COMMENT '标签',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `author` varchar(255) DEFAULT NULL COMMENT '作者',
  `content` varchar(255) DEFAULT NULL COMMENT '内容',
  `uploadtime` datetime DEFAULT NULL COMMENT '上传时间',
  `status` tinyint DEFAULT NULL COMMENT '是否发布',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of article
-- ----------------------------
BEGIN;
INSERT INTO `article` VALUES (1, '美食', '舌尖上的中国第一季', 'Bruce', '通过中华美食的多个侧面，来展现食物给中国人生活带来的仪式、伦理等方面的文化；见识中国特色食材以及与食物相关、构成中国美食特有气质的一系列元素；了解中华饮食文化的精致和源远流长', '2019-01-09 19:08:09', 1);
COMMIT;

-- ----------------------------
-- Table structure for comment
-- ----------------------------
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
  `id` int NOT NULL COMMENT '序号',
  `reviewers` varchar(255) DEFAULT NULL COMMENT '评论者',
  `content` varchar(255) DEFAULT NULL COMMENT '内容',
  `commtime` datetime DEFAULT NULL COMMENT '评论时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of comment
-- ----------------------------
BEGIN;
INSERT INTO `comment` VALUES (1, 'Bruce', '测试评论内容', '2019-01-09 19:08:09');
COMMIT;

-- ----------------------------
-- Table structure for dict
-- ----------------------------
DROP TABLE IF EXISTS `dict`;
CREATE TABLE `dict` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '序号',
  `key` varchar(255) DEFAULT NULL COMMENT 'key',
  `value` varchar(255) DEFAULT NULL COMMENT 'value',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of dict
-- ----------------------------
BEGIN;
INSERT INTO `dict` VALUES (1, '1', '已完成');
INSERT INTO `dict` VALUES (2, '0', '进行中');
INSERT INTO `dict` VALUES (3, '-1', '未完成');
INSERT INTO `dict` VALUES (4, '1', '普通用户');
INSERT INTO `dict` VALUES (5, '2', '管理员');
INSERT INTO `dict` VALUES (6, '10', '超级管理员');
COMMIT;

-- ----------------------------
-- Table structure for file
-- ----------------------------
DROP TABLE IF EXISTS `file`;
CREATE TABLE `file` (
  `id` int NOT NULL COMMENT '序号',
  `realname` varchar(255) DEFAULT NULL COMMENT '真实名称',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '存放路径',
  `savename` varchar(255) DEFAULT NULL COMMENT '保存的唯一名称',
  `type` varchar(255) DEFAULT NULL COMMENT '后缀名',
  `size` double DEFAULT NULL COMMENT '文件大小',
  `userid` int DEFAULT NULL COMMENT '用户ID，标识谁存的',
  `time` datetime DEFAULT NULL COMMENT '保存时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of file
-- ----------------------------
BEGIN;
INSERT INTO `file` VALUES (1, 'lion', '/home/bruce/www/upload/2019/01/17/', 'c5319111-218f-4d16-8ef7-40c452323be2', 'jpg', 28948, 1, '2019-01-17 14:43:07');
INSERT INTO `file` VALUES (2, 'name', '/home/bruce/www/upload/2019/01/17/', '7cae505c-c910-418e-852f-854fa9dcc578', 'png', 20517, 1, '2019-01-17 14:48:59');
INSERT INTO `file` VALUES (3, 'lion', '/home/bruce/www/upload/2019/01/17/', '312c2cbb-783f-45b2-a974-ee118f3e05ca', 'jpg', 28948, 1, '2019-01-17 14:52:16');
INSERT INTO `file` VALUES (4, 'ieasemusic', '/home/bruce/www/upload/2019/01/18/', '5497a0ad-c6d3-472b-a79f-4c0e15de9128', 'png', 8293, 1, '2019-01-18 01:57:53');
INSERT INTO `file` VALUES (5, 'navicat', '/home/bruce/www/upload/2019/01/18/', '68ea24f1-edd9-4b46-9ce9-d8a9492e35a4', 'png', 33995, 1, '2019-01-18 02:03:26');
INSERT INTO `file` VALUES (6, 'lion', '/home/bruce/www/upload/2019/01/18/', '8f64d0a0-644f-4174-898a-7e9e6e5f67a6', 'jpg', 28948, 1, '2019-01-18 02:21:36');
INSERT INTO `file` VALUES (7, 'img', '/home/bruce/www/upload/2019/01/18/', 'bb6c69b5-a579-4f3a-9e37-0d1442d468ae', 'jpeg', 5476, 1, '2019-01-18 02:22:46');
INSERT INTO `file` VALUES (8, 'img', '/home/bruce/www/upload/2019/01/18/', '27d845e1-c318-4df0-b153-f5d6a90db2dc', 'jpeg', 5476, 1, '2019-01-18 02:32:41');
INSERT INTO `file` VALUES (9, 'img', '/home/bruce/www/upload/2019/01/18/', '3305e2e1-180e-4353-85a6-bed5c2325a64', 'jpeg', 5476, 1, '2019-01-18 02:34:13');
INSERT INTO `file` VALUES (10, 'img', '/home/bruce/www/upload/2019/01/18/', '7c93aa76-9f44-4835-b6d7-adfa61ef6303', 'jpeg', 5476, 1, '2019-01-18 02:40:54');
INSERT INTO `file` VALUES (11, 'name', '/home/bruce/www/upload/2019/01/18/', '6bb211e2-e133-403b-ae10-7e540a65ea8a', 'png', 20517, 1, '2019-01-18 02:41:37');
INSERT INTO `file` VALUES (12, 'lion', '/home/bruce/www/upload/2019/01/18/', 'dae13459-6529-4ded-b587-a1f7500475dc', 'jpg', 28948, 1, '2019-01-18 02:41:37');
INSERT INTO `file` VALUES (13, '', '/home/bruce/www/upload/2019/01/18/', '6a801471-7eaf-42c3-8d89-48c6fe10c18f', '', 1971, 1, '2019-01-18 07:15:08');
INSERT INTO `file` VALUES (14, 'mac-desktop', '/home/bruce/www/upload/2019/01/18/', '944dcf08-6a4d-4108-b2cb-dd5822e70602', 'jpg', 13058176, 1, '2019-01-18 07:32:15');
INSERT INTO `file` VALUES (15, 'name', '/home/bruce/www/upload/2019/01/18/', '492f1bc1-00ac-4cd5-8362-f96dd8000741', 'png', 20517, 1, '2019-01-18 07:35:03');
INSERT INTO `file` VALUES (16, 'name', '/home/bruce/www/upload/2019/01/18/', 'aefc6921-dd3b-401e-91c3-e79df1d8a880', 'png', 20517, 1, '2019-01-18 08:07:30');
INSERT INTO `file` VALUES (17, 'sky', '/home/bruce/www/upload/2019/01/19/', 'a94a1e6b-899b-4fb3-8d79-96aa8c3922bb', 'jpg', 278938, 1, '2019-01-19 06:02:54');
INSERT INTO `file` VALUES (18, 'robomongo', '/home/bruce/www/upload/2019/01/19/', 'b2d53779-c33e-4d1d-ba89-1bee093cc9c9', '.png', 10457, 1, '2019-01-19 06:06:43');
INSERT INTO `file` VALUES (19, 'lion', '/home/bruce/www/upload/2019/01/19/', 'cd4a445d-28aa-47a2-9163-723da0a4bd10', 'jpg', 28948, 1, '2019-01-19 06:08:48');
INSERT INTO `file` VALUES (20, '', '/home/bruce/www/upload/2019/01/19/', 'f04c73dd-a1bd-433e-8b36-a0a52af0c2b6', 'file', 1971, 1, '2019-01-19 06:10:00');
INSERT INTO `file` VALUES (21, 'nginx', '/home/bruce/www/upload/2019/01/19/', 'd4cd6da6-c5f6-4936-a080-ae48d86bf72e', 'file', 1971, 1, '2019-01-19 06:10:51');
INSERT INTO `file` VALUES (22, 'img', '/home/bruce/www/upload/2019/01/19/', '54354b32-a6f0-430d-ae2a-1045f8c86e1c', 'jpeg', 5476, 1, '2019-01-19 06:11:09');
COMMIT;

-- ----------------------------
-- Table structure for forum
-- ----------------------------
DROP TABLE IF EXISTS `forum`;
CREATE TABLE `forum` (
  `id` int NOT NULL COMMENT '序号',
  `poster` varchar(255) DEFAULT NULL COMMENT '发布者',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `content` varchar(255) DEFAULT NULL COMMENT '内容',
  `posttime` datetime DEFAULT NULL COMMENT '发布时间',
  `top` tinyint DEFAULT NULL COMMENT '是否置顶',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of forum
-- ----------------------------
BEGIN;
INSERT INTO `forum` VALUES (1, 'Brce', 'https://wx4.sinaimg.cn/mw1024/5db11ff4gy1fmx4keaw9pj20dw08caa4.jpg', '为什么花儿这么么红', '2019-01-09 19:08:09', 1);
COMMIT;

-- ----------------------------
-- Table structure for im
-- ----------------------------
DROP TABLE IF EXISTS `im`;
CREATE TABLE `im` (
  `id` int NOT NULL COMMENT '序号',
  `userId` int DEFAULT NULL COMMENT '用户Id',
  `groupId` int DEFAULT NULL COMMENT '用户组Id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of im
-- ----------------------------
BEGIN;
INSERT INTO `im` VALUES (1, 1, 1);
INSERT INTO `im` VALUES (2, 1, 2);
INSERT INTO `im` VALUES (3, 1, 3);
COMMIT;

-- ----------------------------
-- Table structure for im_group
-- ----------------------------
DROP TABLE IF EXISTS `im_group`;
CREATE TABLE `im_group` (
  `id` int NOT NULL COMMENT '序号',
  `groupid` int DEFAULT NULL COMMENT '用户组Id',
  `groupname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户组名字',
  `userid` int DEFAULT NULL COMMENT '用户Id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of im_group
-- ----------------------------
BEGIN;
INSERT INTO `im_group` VALUES (1, 1, '创始人', 1);
INSERT INTO `im_group` VALUES (2, 1, '创始人', 2);
INSERT INTO `im_group` VALUES (3, 1, '创始人', 3);
INSERT INTO `im_group` VALUES (4, 2, '测试', 2);
INSERT INTO `im_group` VALUES (5, 2, '测试', 3);
INSERT INTO `im_group` VALUES (6, 3, '名星', 4);
COMMIT;

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
  `id` int NOT NULL COMMENT '序号',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of message
-- ----------------------------
BEGIN;
INSERT INTO `message` VALUES (1, '新年快乐', '2019-01-09 19:08:09');
COMMIT;

-- ----------------------------
-- Table structure for message_detail
-- ----------------------------
DROP TABLE IF EXISTS `message_detail`;
CREATE TABLE `message_detail` (
  `id` int NOT NULL COMMENT '序号',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '内容',
  `time` datetime DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of message_detail
-- ----------------------------
BEGIN;
INSERT INTO `message_detail` VALUES (1, '新年快乐', '<p>一直以来，layui 秉承无偿开源的初心，虔诚致力于服务各层次前后端 Web 开发者，在商业横飞的当今时代，这一信念从未动摇。即便身单力薄，仍然重拾决心，埋头造轮，以尽可能地填补产品本身的缺口。在过去的一段的时间，我一直在寻求持久之道，已维持你眼前所见的一切。而 layuiAdmin 是我们尝试解决的手段之一。我相信真正有爱于 layui 生态的你，定然不会错过这一拥抱吧。</p><p>子曰：君子不用防，小人防不住。请务必通过官网正规渠道，获得 <a href=\\\"http://www.layui.com/admin/\\\" target=\\\"_blank\\\">layuiAdmin</a>！</p><p>—— 贤心（<a href=\\\"http://www.layui.com/\\\" target=\\\"_blank\\\">layui.com</a>）</p>', '2019-01-09 19:08:09');
COMMIT;

-- ----------------------------
-- Table structure for prograss
-- ----------------------------
DROP TABLE IF EXISTS `prograss`;
CREATE TABLE `prograss` (
  `id` int NOT NULL COMMENT '序号',
  `prograss` varchar(255) DEFAULT NULL COMMENT '内容',
  `time` datetime DEFAULT NULL COMMENT '持续时间',
  `complete` tinyint DEFAULT NULL COMMENT '是否完成，0表示进行中，1表示已完成，-1表示未完成',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of prograss
-- ----------------------------
BEGIN;
INSERT INTO `prograss` VALUES (1, '开会', '2019-01-09 19:08:09', 1);
INSERT INTO `prograss` VALUES (2, '项目开发', '2019-01-09 19:08:09', 0);
INSERT INTO `prograss` VALUES (3, '修改bug', '2019-01-09 19:08:09', -1);
COMMIT;

-- ----------------------------
-- Table structure for reply
-- ----------------------------
DROP TABLE IF EXISTS `reply`;
CREATE TABLE `reply` (
  `id` int NOT NULL COMMENT '序号',
  `replyer` varchar(255) DEFAULT NULL COMMENT '恢复者',
  `cardid` varchar(255) DEFAULT NULL COMMENT '编号',
  `avatar` varchar(255) DEFAULT NULL COMMENT '头像',
  `content` varchar(255) DEFAULT NULL COMMENT '内容',
  `replytime` datetime DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of reply
-- ----------------------------
BEGIN;
INSERT INTO `reply` VALUES (1, 'Bruce', '1001', 'https://wx2.sinaimg.cn/mw690/5db11ff4gy1fmx4kec5bvj20eb0h3mxh.jpg', '有眼光，我也喜欢胡歌！', '2019-01-09 19:08:09');
COMMIT;

-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles` (
  `id` int NOT NULL COMMENT '序列号',
  `role` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `descr` varchar(255) DEFAULT NULL COMMENT '描述',
  `limits` varchar(255) DEFAULT NULL COMMENT '权利说明',
  `checked` tinyint DEFAULT NULL COMMENT '是否审批',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of roles
-- ----------------------------
BEGIN;
INSERT INTO `roles` VALUES (1, '普通用户', '一般用户', '只能浏览', 1);
INSERT INTO `roles` VALUES (2, '管理员', '事情很多，权利很大', '负责管理维护网站运行：新建新闻，发布新闻', 1);
INSERT INTO `roles` VALUES (3, '超级管理员', '拥有至高无上的权利', '新建板块，新建管理员等所有事务', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `TITLE` varchar(30) DEFAULT NULL COMMENT '菜单标题',
  `NAME` varchar(300) DEFAULT NULL COMMENT '菜单的data-name字段，基本上对应于URL的后半部，比如：/user/deleteUser的deleteUser',
  `JUMP` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单对应的页面url',
  `LEVEL` int DEFAULT NULL COMMENT '表示第几层',
  `PCODE` varchar(60) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '父级编码，0是顶级，1是第一级',
  `CODE` varchar(60) DEFAULT NULL COMMENT '子级编码',
  `FLAG` int DEFAULT NULL COMMENT '是否有效，1是有效，0是无效',
  `CREATETIME` datetime DEFAULT NULL COMMENT '创建时间',
  `ICON` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单对应的图标',
  `HASCHILD` int DEFAULT NULL COMMENT '1表示有子菜单，0表示没子菜单',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=108 DEFAULT CHARSET=utf8 COMMENT='菜单模块';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, '主页', '', '', 1, '0', '1', 1, '2019-01-09 19:08:09', 'layui-icon-home', 1);
INSERT INTO `sys_menu` VALUES (2, '组件', 'component', '', 1, '0', '2', 1, '2019-01-09 19:08:09', 'layui-icon-component', 1);
INSERT INTO `sys_menu` VALUES (3, '页面', 'template', '', 1, '0', '3', 1, '2019-01-09 19:08:09', 'layui-icon-template', 1);
INSERT INTO `sys_menu` VALUES (4, '应用', 'app', '', 1, '0', '4', 1, '2019-01-09 19:08:09', 'layui-icon-app', 1);
INSERT INTO `sys_menu` VALUES (5, '高级', 'senior', '', 1, '0', '5', 1, '2019-01-09 19:08:09', 'layui-icon-senior', 1);
INSERT INTO `sys_menu` VALUES (6, '用户', 'user', '', 1, '0', '6', 1, '2019-01-09 19:08:09', 'layui-icon-user', 1);
INSERT INTO `sys_menu` VALUES (7, '设置', 'set', '', 1, '0', '7', 1, '2019-01-09 19:08:09', 'layui-icon-set', 1);
INSERT INTO `sys_menu` VALUES (8, '授权', 'get', '', 1, '0', '8', 1, '2019-01-09 19:08:09', 'layui-icon-auz', 0);
INSERT INTO `sys_menu` VALUES (9, '控制台', '', '/', 2, '1', '1', 1, '2019-01-09 19:07:10', '', 0);
INSERT INTO `sys_menu` VALUES (10, '主页一', 'homepage1', 'home/homepage1', 2, '1', '2', 1, '2019-01-09 19:07:50', '', 0);
INSERT INTO `sys_menu` VALUES (11, '主页二', 'homepage2', 'home/homepage2', 2, '1', '3', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (12, '栅格', 'grid', '', 2, '2', '1', 1, '2019-01-09 19:08:09', '', 1);
INSERT INTO `sys_menu` VALUES (13, '按钮', 'button', '', 2, '2', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (14, '表单', 'form', '', 2, '2', '3', 1, '2019-01-09 19:08:09', '', 1);
INSERT INTO `sys_menu` VALUES (15, '导航', 'nav', '', 2, '2', '4', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (16, '选项卡', 'tabs', '', 2, '2', '5', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (17, '进度条', 'progress', '', 2, '2', '6', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (18, '面板', 'panel', '', 2, '2', '7', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (19, '徽章', 'badge', '', 2, '2', '8', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (20, '时间线', 'timeline', '', 2, '2', '9', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (21, '动画', 'anim', '', 2, '2', '10', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (22, '辅助', 'auxiliar', '', 2, '2', '11', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (23, '通用弹层', 'layer', '', 2, '2', '12', 1, '2019-01-09 19:08:09', '', 1);
INSERT INTO `sys_menu` VALUES (24, '日期时间', 'laydate', '', 2, '2', '13', 1, '2019-01-09 19:08:09', '', 1);
INSERT INTO `sys_menu` VALUES (25, '表格', 'table', '', 2, '2', '14', 1, '2019-01-09 19:08:09', '', 1);
INSERT INTO `sys_menu` VALUES (26, '分页', 'laypage', '', 2, '2', '15', 1, '2019-01-09 19:08:09', '', 1);
INSERT INTO `sys_menu` VALUES (27, '上传', 'upload', '', 2, '2', '16', 1, '2019-01-09 19:08:09', '', 1);
INSERT INTO `sys_menu` VALUES (28, '评分', 'rate', '', 2, '2', '17', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (29, '轮播', 'carousel', '', 2, '2', '18', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (30, '流加载', 'flow', '', 2, '2', '19', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (31, '工具', 'util', '', 2, '2', '20', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (32, '代码修饰', 'code', '', 2, '2', '21', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (33, '即时聊天', 'layim', 'senior/im/', 2, '2', '22', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (34, '个人主页', 'personalpage', 'template/personalpage', 2, '3', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (35, '通讯录', 'addresslist', 'template/addresslist', 2, '3', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (36, '商品列表', 'goodslist', 'template/goodslist', 2, '3', '3', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (37, '留言板', 'msgboard', 'template/msgboard', 2, '3', '4', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (38, '搜索结果', 'search', 'template/search', 2, '3', '5', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (39, '注册', 'reg', 'user/reg', 2, '3', '6', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (40, '登入', 'login', 'user/login', 2, '3', '7', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (41, '忘记密码', 'forget', 'user/forget', 2, '3', '8', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (42, '404', '404', 'template/tips/404', 2, '3', '9', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (43, '错误提示', 'error', 'template/tips/error', 2, '3', '10', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (44, '内嵌页面', '', '', 2, '3', '11', 1, '2019-01-09 19:08:09', '', 1);
INSERT INTO `sys_menu` VALUES (45, '内容系统', 'content', '', 2, '4', '1', 1, '2019-01-09 19:08:09', '', 1);
INSERT INTO `sys_menu` VALUES (46, '社区系统', 'forum', '', 2, '4', '2', 1, '2019-01-09 19:08:09', '', 1);
INSERT INTO `sys_menu` VALUES (47, '消息中心', 'message', '', 2, '4', '3', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (48, '工单系统', 'workorder', 'app/workorder/list', 2, '4', '4', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (49, '通讯系统', 'im', '', 2, '5', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (50, 'Echarts集成', 'echarts', '', 2, '5', '2', 1, '2019-01-09 19:08:09', '', 1);
INSERT INTO `sys_menu` VALUES (51, '网站用户', 'user', 'user/user/list', 2, '6', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (52, '后台管理员', 'administrators-list', 'user/administrators/list', 2, '6', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (53, '角色管理', 'administrators-rule', 'user/administrators/role', 2, '6', '3', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (54, '系统设置', 'system', '', 2, '7', '1', 1, '2019-01-09 19:08:09', '', 1);
INSERT INTO `sys_menu` VALUES (55, '我的设置', 'user', '', 2, '7', '2', 1, '2019-01-09 19:08:09', '', 1);
INSERT INTO `sys_menu` VALUES (56, '等比例列表排列', 'list', '', 3, '12', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (57, '按移动端排列', 'mobile', '', 3, '12', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (58, '移动桌面端组合', 'mobile-pc', '', 3, '12', '3', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (59, '全端复杂组合', 'all', '', 3, '12', '4', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (60, '低于桌面堆叠排列', 'stack', '', 3, '12', '5', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (61, '九宫格', 'speed-dial', '', 3, '12', '6', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (62, '表单元素', 'element', '', 3, '14', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (63, '表单组合', 'group', '', 3, '14', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (64, '功能演示', 'list', '', 3, '23', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (65, '特殊示例', 'special-demo', '', 3, '23', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (66, '风格定制', 'theme', '', 3, '23', '3', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (67, '功能演示一', 'demo1', '', 3, '24', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (68, '功能演示二', 'demo2', '', 3, '24', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (69, '设定主题', 'theme', '', 3, '24', '3', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (70, '特殊示例', 'special-demo', '', 3, '24', '4', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (71, '简单数据表格', 'simple', '', 3, '25', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (72, '列宽自动分配', 'auto', '', 3, '25', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (73, '赋值已知数据', 'data', '', 3, '25', '3', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (74, '转化静态表格', 'tostatic', '', 3, '25', '4', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (75, '开启分页', 'page', '', 3, '25', '5', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (76, '自定义分页', 'resetPage', '', 3, '25', '6', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (77, '高度最大适应', 'height', '', 3, '25', '7', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (78, '开启复选框', 'checkbox', '', 3, '25', '8', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (79, '开启单元格编辑', 'cellEdit', '', 3, '25', '9', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (80, '加入表单元素', 'form', '', 3, '25', '10', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (81, '设置单元格样式', 'style', '', 3, '25', '11', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (82, '固定列', 'fixed', '', 3, '25', '12', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (83, '数据操作', 'operate', '', 3, '25', '13', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (84, '数据表格的重载', 'reload', '', 3, '25', '14', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (85, '设置初始排序', 'initSort', '', 3, '25', '15', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (86, '监听单元格事件', 'cellEvent', '', 3, '25', '16', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (87, '复杂表头', 'thead', '', 3, '25', '17', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (88, '功能演示一', 'demo1', '', 3, '26', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (89, '功能演示二', 'demo2', '', 3, '26', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (90, '功能演示一', 'demo1', '', 3, '27', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (91, '功能演示二', 'demo2', '', 3, '27', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (92, '百度一下', '', '/iframe/link/baidu', 3, '44', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (93, 'layui官网', '', '/iframe/link/layui', 3, '44', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (94, 'layuiAdmin官网', '', '/iframe/link/layuiAdmin', 3, '44', '2', 3, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (95, '文章列表', 'list', '', 3, '45', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (96, '分类管理', 'tags', '', 3, '45', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (97, '评论管理', 'comment', '', 3, '45', '3', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (98, '帖子列表', 'list', '', 3, '46', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (99, '回帖列表', 'replys', '', 3, '46', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (100, '折线图', 'line', '', 3, '50', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (101, '柱状图', 'bar', '', 3, '50', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (102, '地图', 'map', '', 3, '50', '3', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (103, '网站设置', 'website', '', 3, '54', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (104, '邮件服务', 'email', '', 3, '54', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (105, '基本资料', 'info', '', 3, '55', '1', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (106, '修改密码', 'password', '', 3, '55', '2', 1, '2019-01-09 19:08:09', '', 0);
INSERT INTO `sys_menu` VALUES (107, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for top_card
-- ----------------------------
DROP TABLE IF EXISTS `top_card`;
CREATE TABLE `top_card` (
  `id` int NOT NULL COMMENT '序号',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `username` varchar(255) DEFAULT NULL COMMENT '用户名',
  `channel` varchar(255) DEFAULT NULL COMMENT '公告',
  `href` varchar(255) DEFAULT NULL COMMENT '链接',
  `crt` bigint DEFAULT NULL COMMENT '数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of top_card
-- ----------------------------
BEGIN;
INSERT INTO `top_card` VALUES (1, '模拟数据1', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (2, '模拟数据2', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (3, '模拟数据3', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (4, '模拟数据4', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (5, '模拟数据5', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (6, '模拟数据6', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (7, '模拟数据7', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (8, '模拟数据8', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (9, '模拟数据9', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (10, '模拟数据10', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (11, '模拟数据11', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (12, '模拟数据12', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (13, '模拟数据13', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (14, '模拟数据14', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (15, '模拟数据15', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (16, '模拟数据16', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (17, '模拟数据17', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (18, '模拟数据18', '木杉', '公告', 'https://www.brucekong.com', 1000);
INSERT INTO `top_card` VALUES (19, '模拟数据19', '木杉', '公告', 'https://www.brucekong.com', 1000);
COMMIT;

-- ----------------------------
-- Table structure for top_search
-- ----------------------------
DROP TABLE IF EXISTS `top_search`;
CREATE TABLE `top_search` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '序列号',
  `keywords` varchar(255) DEFAULT NULL COMMENT '关键词',
  `frequency` bigint DEFAULT NULL COMMENT '频率',
  `userNums` bigint DEFAULT NULL COMMENT '用户数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of top_search
-- ----------------------------
BEGIN;
INSERT INTO `top_search` VALUES (1, '模拟数据1', 5521, 808);
INSERT INTO `top_search` VALUES (2, '模拟数据2', 5521, 808);
INSERT INTO `top_search` VALUES (3, '模拟数据3', 5521, 808);
INSERT INTO `top_search` VALUES (4, '模拟数据4', 5521, 808);
INSERT INTO `top_search` VALUES (5, '模拟数据5', 5521, 808);
INSERT INTO `top_search` VALUES (6, '模拟数据6', 5521, 808);
INSERT INTO `top_search` VALUES (7, '模拟数据7', 5521, 808);
INSERT INTO `top_search` VALUES (8, '模拟数据8', 5521, 808);
INSERT INTO `top_search` VALUES (9, '模拟数据9', 5521, 808);
INSERT INTO `top_search` VALUES (10, '模拟数据10', 5521, 808);
INSERT INTO `top_search` VALUES (11, '模拟数据11', 5521, 808);
INSERT INTO `top_search` VALUES (12, '模拟数据12', 5521, 808);
INSERT INTO `top_search` VALUES (13, '模拟数据13', 5521, 808);
INSERT INTO `top_search` VALUES (14, '模拟数据14', 5521, 808);
INSERT INTO `top_search` VALUES (15, '模拟数据15', 5521, 808);
INSERT INTO `top_search` VALUES (16, '模拟数据16', 5521, 808);
INSERT INTO `top_search` VALUES (17, '模拟数据17', 5521, 808);
INSERT INTO `top_search` VALUES (18, '模拟数据18', 5521, 808);
INSERT INTO `top_search` VALUES (19, '模拟数据19', 5521, 808);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'id',
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名，即用户账号',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户密码',
  `realname` varchar(255) DEFAULT NULL COMMENT '真实姓名',
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
  `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机号码',
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `sex` varchar(4) DEFAULT NULL COMMENT '性别',
  `province` varchar(255) DEFAULT NULL COMMENT '省',
  `city` varchar(255) DEFAULT NULL COMMENT '所在城市',
  `zone` varchar(255) DEFAULT NULL COMMENT '区县',
  `street` varchar(255) DEFAULT NULL COMMENT '街道',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `house` varchar(255) DEFAULT NULL COMMENT '单元号',
  `sign` varchar(255) DEFAULT NULL COMMENT '签名',
  `experience` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '积分',
  `ip` varchar(255) DEFAULT NULL COMMENT 'IP',
  `jointime` datetime DEFAULT NULL COMMENT '加入时间',
  `status` tinyint DEFAULT NULL COMMENT '是否在线',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'admin', '202cb962ac59075b964b07152d234b70', '木杉', 'https://blog.brucekong.com/css/images/avatar.png', '17854257215', 'kongbin0325@hotmail.com', '男', '山东省', '济南', '历下区', '智远街道', '林景山庄', '东区13栋2单元', '签名', '365', '192.168.1.11', '2019-01-09 19:08:09', 1);
COMMIT;

-- ----------------------------
-- Table structure for user_role
-- ----------------------------
DROP TABLE IF EXISTS `user_role`;
CREATE TABLE `user_role` (
  `id` int NOT NULL COMMENT '序列号',
  `userid` int DEFAULT NULL COMMENT '用户ID',
  `roleid` int NOT NULL COMMENT '角色ID',
  PRIMARY KEY (`id`),
  KEY `roleid` (`roleid`),
  KEY `userid` (`userid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_role
-- ----------------------------
BEGIN;
INSERT INTO `user_role` VALUES (1, 1, 1);
INSERT INTO `user_role` VALUES (2, 2, 2);
INSERT INTO `user_role` VALUES (3, 3, 3);
COMMIT;

-- ----------------------------
-- Table structure for workorder
-- ----------------------------
DROP TABLE IF EXISTS `workorder`;
CREATE TABLE `workorder` (
  `id` int NOT NULL COMMENT '序号',
  `title` varchar(255) DEFAULT NULL COMMENT '标题',
  `attr` varchar(255) DEFAULT NULL COMMENT '类型',
  `progress` varchar(255) DEFAULT NULL COMMENT '进度',
  `submit` varchar(255) DEFAULT NULL COMMENT '提交者',
  `accept` varchar(255) DEFAULT NULL COMMENT '分配给谁',
  `state` varchar(255) DEFAULT NULL COMMENT '进度（文字描述）',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of workorder
-- ----------------------------
BEGIN;
INSERT INTO `workorder` VALUES (1, '移动支付踏入马来西亚，聚合支付紧随其后', '公告', '25%', 'Bruce', '员工-1', '处理中');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
